﻿using NetTopologySuite.Geometries;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Threading.Tasks;

namespace housingsafety.server.Models
{
    public class Import_Yhpc
    {
           
        public string xzqdmname { get; set; }

        public string townname { get; set; }

        public string villagename { get; set; }
        [Key]
        [Column("id")]
        [StringLength(36)]
        public string Id { get; set; }
        [Column("result")]
        public int? Result { get; set; }
        [Column("city_result")]
        public int? CityResult { get; set; }
        [Column("bh")]
        [StringLength(50)]
        public string Bh { get; set; }
        [Column("province")]
        [StringLength(6)]
        public string Province { get; set; }
        [Column("city")]
        [StringLength(6)]
        public string City { get; set; }
        [Column("xzqdm")]
        [StringLength(6)]
        public string Xzqdm { get; set; }
        [Column("town")]
        [StringLength(12)]
        public string Town { get; set; }
        [Column("village")]
        [StringLength(12)]
        public string Village { get; set; }
        [Column("zu_qg")]
        [StringLength(100)]
        public string ZuQg { get; set; }
        [Column("lu_qg")]
        [StringLength(100)]
        public string LuQg { get; set; }
        [Column("hao_qg")]
        [StringLength(100)]
        public string HaoQg { get; set; }
        [Column("address")]
        [StringLength(500)]
        public string Address { get; set; }
        [Column("fwyt")]
        [StringLength(2)]
        public string Fwyt { get; set; }
        [Column("sub_fwyt")]
        [StringLength(2)]
        public string SubFwyt { get; set; }
        [Column("jzgn")]
        [StringLength(50)]
        public string Jzgn { get; set; }
        [Column("qtjzgn")]
        [StringLength(20)]
        public string Qtjzgn { get; set; }
        [Column("tdxz")]
        [StringLength(2)]
        public string Tdxz { get; set; }
        [Column("szqy")]
        [StringLength(30)]
        public string Szqy { get; set; }
        [Column("qtszqy")]
        [StringLength(100)]
        public string Qtszqy { get; set; }
        [Column("cs")]
        public int? Cs { get; set; }
        [Column("dcmj")]
        public double? Dcmj { get; set; }
        [Column("build_time")]
        [StringLength(4)]
        public string BuildTime { get; set; }
        [Column("sjfs")]
        [StringLength(2)]
        public string Sjfs { get; set; }
        [Column("sgdw")]
        [StringLength(2)]
        public string Sgdw { get; set; }
        [Column("jglx")]
        [StringLength(5)]
        public string Jglx { get; set; }
        [Column("sfsyyzb")]
        [StringLength(2)]
        public string Sfsyyzb { get; set; }
        [Column("sfgkj")]
        [StringLength(2)]
        public string Sfgkj { get; set; }
        [Column("gkjcs")]
        public int? Gkjcs { get; set; }
        [Column("gkjnr")]
        [StringLength(20)]
        public string Gkjnr { get; set; }
        [Column("qtgkjnr")]
        [StringLength(100)]
        public string Qtgkjnr { get; set; }
        [Column("zxsfkbztjg")]
        [StringLength(2)]
        public string Zxsfkbztjg { get; set; }
        [Column("xzqksx")]
        [StringLength(30)]
        public string Xzqksx { get; set; }
        [Column("sfwfjs")]
        [StringLength(2)]
        public string Sfwfjs { get; set; }
        [Column("wfjsqk")]
        [StringLength(20)]
        public string Wfjsqk { get; set; }
        [Column("sfwfsp")]
        [StringLength(2)]
        public string Sfwfsp { get; set; }
        [Column("wfspqk")]
        [StringLength(20)]
        public string Wfspqk { get; set; }
        [Column("sfczdzzhyh")]
        [StringLength(2)]
        public string Sfczdzzhyh { get; set; }
        [Column("yhlx")]
        [StringLength(20)]
        public string Yhlx { get; set; }
        [Column("qtyhlx")]
        [StringLength(100)]
        public string Qtyhlx { get; set; }
        [Column("aqyhcp")]
        [StringLength(2)]
        public string Aqyhcp { get; set; }
        [Column("fxbw")]
        [StringLength(20)]
        public string Fxbw { get; set; }
        [Column("qtfxbw")]
        [StringLength(100)]
        public string Qtfxbw { get; set; }
        [Column("sfaqjd")]
        [StringLength(2)]
        public string Sfaqjd { get; set; }
        [Column("fwaqdj")]
        [StringLength(20)]
        public string Fwaqdj { get; set; }
        [Column("jdfxbw")]
        [StringLength(20)]
        public string Jdfxbw { get; set; }
        [Column("jdqtfxbw")]
        [StringLength(100)]
        public string Jdqtfxbw { get; set; }
        [Column("photo")]
        [StringLength(36)]
        public string Photo { get; set; }
        [Column("fwbh")]
        [StringLength(15)]
        public string Fwbh { get; set; }
        [Column("fwlb")]
        [StringLength(4)]
        public string Fwlb { get; set; }
        [Column("qtjglx")]
        [StringLength(100)]
        public string Qtjglx { get; set; }
        [Column("status")]
        public int? Status { get; set; }
        [Column("pcr_id")]
        [StringLength(36)]
        public string PcrId { get; set; }
        [Column("pcr")]
        [StringLength(50)]
        public string Pcr { get; set; }
        [Column("pcrdh")]
        [StringLength(11)]
        public string Pcrdh { get; set; }
        [Column("pcrjg")]
        [StringLength(100)]
        public string Pcrjg { get; set; }
        [Column("pcrsfzh")]
        [StringLength(100)]
        public string Pcrsfzh { get; set; }
        [Column("geom")]
        public Geometry Geom { get; set; }
        [Column("pcqk")]
        public int? Pcqk { get; set; }
        [Column("yhfwbh")]
        [StringLength(36)]
        public string Yhfwbh { get; set; }
        [Column("pcsj", TypeName = "timestamp(6) without time zone")]
        public DateTime? Pcsj { get; set; }
        [Column("jdbg_file")]
        [StringLength(36)]
        public string JdbgFile { get; set; }
        [Column("bxypcyy")]
        [StringLength(2)]
        public string Bxypcyy { get; set; }
        [Column("qtbxypcyy")]
        [StringLength(1000)]
        public string Qtbxypcyy { get; set; }
        [Column("jyxkhy")]
        [StringLength(100)]
        public string Jyxkhy { get; set; }
        [Column("cqr")]
        [StringLength(150)]
        public string Cqr { get; set; }
        [Column("sub_jglx")]
        [StringLength(20)]
        public string SubJglx { get; set; }
        [Column("zzcs")]
        [StringLength(20)]
        public string Zzcs { get; set; }
        [Column("glcs")]
        [StringLength(20)]
        public string Glcs { get; set; }
        [Column("qtglcs")]
        [StringLength(100)]
        public string Qtglcs { get; set; }
        [Column("gccs")]
        [StringLength(20)]
        public string Gccs { get; set; }
        [Column("qtgccs")]
        [StringLength(100)]
        public string Qtgccs { get; set; }
        [Column("wfjscc")]
        [StringLength(20)]
        public string Wfjscc { get; set; }
        [Column("qtwfjscc")]
        [StringLength(100)]
        public string Qtwfjscc { get; set; }
        [Column("qtsgdw")]
        [StringLength(100)]
        public string Qtsgdw { get; set; }
        [Column("sfzh")]
        [StringLength(300)]
        public string Sfzh { get; set; }
        [Column("sfzx")]
        [StringLength(2)]
        public string Sfzx { get; set; }
        [Column("dong_qg")]
        [StringLength(100)]
        public string DongQg { get; set; }
        [Column("jdsfaq")]
        [StringLength(2)]
        public string Jdsfaq { get; set; }
        [Column("bxss")]
        [StringLength(2)]
        public string Bxss { get; set; }
        [Column("bxssbw")]
        [StringLength(20)]
        public string Bxssbw { get; set; }
        [Column("qtbxssbw")]
        [StringLength(100)]
        public string Qtbxssbw { get; set; }
        [Column("jddwmc")]
        [StringLength(100)]
        public string Jddwmc { get; set; }
        [Column("tyssxydm")]
        [StringLength(100)]
        public string Tyssxydm { get; set; }
        [Column("jdsj", TypeName = "timestamp(6) without time zone")]
        public DateTime? Jdsj { get; set; }
        [Column("tdxzxflx")]
        [StringLength(20)]
        public string Tdxzxflx { get; set; }
        [Column("qttdxzxflx")]
        [StringLength(100)]
        public string Qttdxzxflx { get; set; }
        [Column("fwmj")]
        public double? Fwmj { get; set; }
        [Column("pc_photo")]
        [StringLength(36)]
        public string PcPhoto { get; set; }
        [Column("zz_photo")]
        [StringLength(36)]
        public string ZzPhoto { get; set; }
        [Column("crjs", TypeName = "timestamp(6) without time zone")]
        public DateTime? Crjs { get; set; }
        [Column("gxsj", TypeName = "timestamp(6) without time zone")]
        public DateTime? Gxsj { get; set; }
        [Column("jznd")]
        [StringLength(2)]
        public string Jznd { get; set; }
        [Column("csjcqlx")]
        [StringLength(2)]
        public string Csjcqlx { get; set; }
        [Column("rymjcslx")]
        [StringLength(20)]
        public string Rymjcslx { get; set; }
        [Column("qtrymjcslx")]
        [StringLength(100)]
        public string Qtrymjcslx { get; set; }
        [Column("pccs")]
        public int? Pccs { get; set; }
        [Column("xgcs")]
        public int? Xgcs { get; set; }
        [Column("hzxm")]
        [StringLength(255)]
        public string Hzxm { get; set; }
        [Required]
        [Column("create_by")]
        [StringLength(50)]
        public string CreateBy { get; set; }
        [Column("create_on", TypeName = "timestamp(6) without time zone")]
        public DateTime CreateOn { get; set; }
        [Column("create_ip")]
        [StringLength(20)]
        public string CreateIp { get; set; }
        [Column("modified_by")]
        [StringLength(50)]
        public string ModifiedBy { get; set; }
        [Column("modified_on", TypeName = "timestamp(6) without time zone")]
        public DateTime? ModifiedOn { get; set; }
        [Column("modified_ip")]
        [StringLength(20)]
        public string ModifiedIp { get; set; }
        [Column("is_delete")]
        public short? IsDelete { get; set; }
        [Column("delete_by")]
        [StringLength(50)]
        public string DeleteBy { get; set; }
        [Column("delete_on", TypeName = "timestamp(6) without time zone")]
        public DateTime? DeleteOn { get; set; }
        [Column("delete_ip")]
        [StringLength(20)]
        public string DeleteIp { get; set; }

        [Column("btglx")]
        [StringLength(255)]
        public string Btglx { get; set; }

        [Column("city_btglx")]
        [StringLength(255)]
        public string CityBtglx { get; set; }

        [Column("aqyhrycc")]
        public int? Aqyhrycc { get; set; }

        [Column("ccsj")]
        [StringLength(255)]
        public string Ccsj { get; set; }

        [Column("ccjl")]
        [StringLength(255)]
        public string Ccjl { get; set; }
    }
}
